# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月17日
"""
import openpyxl
myBook = openpyxl.load_workbook('销量排行表.xlsx',data_only=True)
mySheet=myBook.active
myRows=list(mySheet.values)[1:]
while mySheet.max_row>1:
	mySheet.delete_rows(2)
myList=['清华大学出版社','中国水利水电出版社']
for myRow in myRows:
	if myRow[3] in myList:
		mySheet.append(myRow)
myBook.save('结果表-销量排行榜.xlsx')

